{"text_format":"1","workbook":"xlsx","n_sheets":2,"sheets":["README","REG"],"not_rendered":{"charts":0,"images":2,"macros":1,"external_links":0,"defined_names":1,"comments":0,"pivot_tables":0},"unopened":[],"bounds":{"document_bytes":16777216,"sheet_cells":100000,"rows_first":2000,"rows_last":500,"rows_between":2000,"halvings":0,"cell_chars":16384,"cell_head_chars":4096},"cells_cut":0,"cells_raw":0,"read":"whole","date_system":"1900"}

{"sheet":"README","index":0,"n_rows":28,"n_cols":7,"rows_kept":28,"cut":false,"hidden":false,"merged":[[3,1,3,2],[13,1,14,4],[16,1,17,4],[13,6,16,12]]}
[]
[null,"Clinical Term Analysis Report",null,null,null,null,"NOTE:"]
[null,null,null,null,null,null,"This will only work if Vision is on DLM485 or above."]
[null,"Enter Date Range",null,null,null,null,"Excel 2010 - Please \"Enable Content\" if a security Warning is displayed"]
[null,"FROM","TO",null,"Registration Status"]
[null,"2016-07-01","2017-06-30",null,"INCLUDE ALL",null,"Excel 2007 - Please enable both Macros... and Data Connections"]
[null,null,null,null,null,null,"Excel 2003 - Is not supported"]
[null,"Read code Count"," Duplicates"]
[null,3,"Yes",null,null,null,"Updated: 04/08/2017"]
[null,null,null,null,null,null,"Version: 1.1"]
[null,"The objective of this report is to find the most common clinical terms being recorded",null,null,null,null,"Created by: Bradley Sieve"]
[null,"by staff, using the rules explained below:"]
[null,null,null,null,null,null,"Disclaimer"]
[null,"Read code Count is the amount of characters in the Read code to use (from left to right) in counting them in the pivot Tables and determining duplicates",null,null,null,null,"In using this Microsoft Excel report you hereby acknowledge that the software cannot be guaranteed error free and may also be subject to how data is being recorded by your practice, and further acknowledge that the existence of any such errors shall not make Vision responsible for any actions you carry out based on these results."]
[]
[]
[null,"Duplicates = Yes will remove duplicate lines of data if the patient id AND partial Read code is the same."]
[]
[]
[null,"Dx tab searches all A to Z Read codes entered in a medical history entity, including 1Z1%"]
[]
[null,"Tests tab searches all Read codes entered in the test results table"]
[]
[null,"PMH tab searches all clinical data Read codes starting 1% or 2%"]
[]
[null,"OPS tab search all clinical data Read codes starting 7%"]
[]
[null,"Other tab search all clinical data Read codes starting 0%, 3%, 4%, 5%, 6%, 8% or 9% "]

{"sheet":"REG","index":1,"n_rows":20,"n_cols":4,"rows_kept":20,"cut":false,"hidden":true,"merged":[]}
["ACTIVE PATIENTS","REG000",null,"YES"]
["Applied","REG001",null,"NO"]
["Permanent","REG002"]
["Temporary Resident < 16 days","REG003"]
["Temporary Resident 16 days to 3 months","REG004"]
["Transferred Out","REG005"]
["Immediately Necessary Treatment","REG006"]
["Emergency Treatment","REG007"]
["Child Health Surveillance","REG008"]
["Contraception","REG009"]
["Maternity","REG010"]
["Minor Surgery","REG011"]
["Private","REG012"]
["Referred","REG013"]
["Walk in Centre","REG014"]
["GP with Special Interest","REG015"]
["Minor Injury Clinic","REG016"]
["HMP Inmate","REG017"]
["Visitor (EC111)","REG018"]
["INCLUDE ALL","NONE"]